Take Control of Numbers (1.0) by Zardetto Sharon

Author:Zardetto, Sharon
Language: eng
Format: epub
Publisher: TidBITS
Published: 2015-04-20T16:00:00+00:00

To re-open the formula editor, double-click the cell, or select the cell and press Option-Return.

A cell displays the results of a formula, but you can see the formula that’s stored in a selected cell in the Smart Cell View at the bottom of the window (Figure 96).

Figure 96: Left: The formula editor open in B5. Right: With B5 selected, the Smart Cell View shows the formula.

Move or Resize the Editor

The editor is easy to move, which is a good thing, since it obscures its own and adjacent cells. Just place your pointer over the editor’s left edge until it changes to the grabber hand, and drag it.

It’s not obvious that you can resize the editor, especially since it automatically expands horizontally as a formula gets longer. To change the length or height, hover over either the bottom or right edge for a resize cursor and drag. To change both dimensions at once, hover over any corner until you see the pointing hand and drag (Figure 97).

Figure 97: Left: Drag the formula editor to any position. Right: Resizing from a corner; note the gray scrollbar that indicates not all of the formula is currently showing.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.